package com.example.superoa.model.mappers;

import java.util.Date;
import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.springframework.data.repository.query.Param;

import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.example.superoa.model.pojos.KqAttendance;

@Mapper
public interface AttendMapper {
	public JSONArray selectDAll();
	public JSONArray selectSousuo(Date kai_date,Date jie_date,int id);
	public JSONArray selectRAll();
	public Integer selectzong(int year,int month,int staff_id);
	public Integer selectattendid();
	public JSONObject selectattendidmont(int staff_id,Date date);
	public JSONObject selectid(int id);
	public Integer selectonePan(Date date);
	public JSONArray selelcttow(int re_class);
	public JSONArray selectRdate(Date kai,Date jie);
	public JSONArray selectattendStaff(int staff_id);
	
	public JSONObject selectStaffDept(Integer id);
	//通过员工id查询员工资料
	public JSONObject selectstaff(Integer id);
	
	public Integer selectfirstDept(Integer id);
	//通过员工id查询到未审核的申请
	public JSONArray selectattendID(Integer staff_id);
	//通过员工id查询自己的申请
	public JSONArray selectattendIDD(Integer staff_id);
	//通过申请id查询申请
	public JSONArray selectshenqiid(Integer id);
} 
